Please note I only have data until 2022-01-04. The rolling average is the mean of that day’s cases as well as the 6 days prior.
Also for the US total aggregate cases, my data is coming from https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv
Same source as Johns Hopkins, so I hope it’s legit.
The red dashed line helps us visualize where our cases used to be. The following table provides the actual days and seven day average cases of those intersections.
I like to check on my state as well.
When parsing for states, my data is coming from here: https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv
Same as NY Times.
Just like the US chart, the red dashed line can help us visualize the last times we were at today’s COVID cases. Below is a table of the exact dates of intersection between today’s cases vs previous cases.
Also, the way the intersection table works is if today’s 7 Day Average Cases = 10000, and we had 9,982 cases on August 2nd, 2021 and 10,190 cases on August 3rd, 2021, then August 2nd, 2021 would be listed in the table.
State populations are coming from here: http://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv
Yes, this is noisy, but you have the option to double click any number of states on the right to isolate.
Now, I’m no public health expert, but it does seem like the higher vaccine rate a state has, the lower the COVID cases are. Let’s just let the data talk.
Vaccination data from here: https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/vaccinations/us_state_vaccinations.csv
Now if that is a little too noisy, I’ll break it down between red and blue.
This is 7 times the amount we had at the lowest 7 day average death count in July.